SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415910 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415910 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960931,830691,329814,531302,68490,200190,845725,523138,39841,275738,862318,35140,377872,277732,697896,501477,385239,1045790,342076,644582,746622,530574,675349,821788,560896,321261,918053,4961,336171,1017489,250302,897421,42224,946175,95417,1013942,463565,599104,112015,295171,128809,107621,45989,676154,752004,527390,603969,547376,948874,551515,54455,833926,243321,961342,920190,97277,1038437,836222,18459,782811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]