SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480896 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480896 [ RunTime:0.002752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250578,189986,1014781,388675,625198,376782,351327,612139,536337,834350,821262,382240,918538,488695,922885,858495,718917,231093,492899,80614,854842,679381,58832,441505,751188,430961,372857,442887,72076,271884,631162,107968,627111,609228,179788,692216,865333,972027,1048453,585510,758745,582544,1024110,838155,141729,178993,647239,932836,166555,171425,408648,866206,909116,569789,841577,456668,672373,791181,761512,374004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]