SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407592 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407592 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647283,1011614,612332,791622,64771,758235,188349,299634,258459,127585,242953,581816,60543,212800,33247,604139,181249,938578,675532,511236,550656,911179,447,649908,661458,649887,856607,158897,858994,148313,603900,544302,1008535,515307,884636,266306,534165,581449,395057,760810,966960,580631,720521,689223,836532,974477,952132,565907,788743,974133,501900,1020794,422753,247313,793320,46013,867426,772645,1033546,243434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]