SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409318 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409318 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640958,985732,881477,938668,316404,220042,707847,362705,713071,102606,371692,385491,133852,441630,239927,50641,577512,437975,424142,74767,230710,541970,266783,41872,382585,84131,763046,1048876,312307,532660,596600,909798,1022187,296433,967744,836829,273953,306201,485298,157189,984818,383252,974907,279563,250724,836105,420445,204386,690317,282681,855285,710227,1017287,624251,685611,575694,55602,183681,777965,1023759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]