SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409228 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409228 [ RunTime:0.003033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940203,219030,866558,226420,106074,84744,388013,437812,714018,639943,889967,467782,784154,109038,634485,316967,828556,666391,898206,107226,481810,742998,90505,742493,705271,23648,600022,479456,348560,86217,125215,4023,636730,679603,759134,952976,74770,780129,298768,685030,730358,641143,372749,1019120,433547,636417,771792,929129,786299,1008780,91684,982909,451468,679035,545737,405346,624745,927749,920108,216786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004621s ]