SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494473 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494473 [ RunTime:0.001349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406982,996980,702559,5136,684044,870035,418980,700256,142056,165525,514930,356839,516973,882236,604986,541587,273500,1044699,246043,785529,332301,884595,540865,461012,653118,118952,605439,849093,368691,800285,320535,914808,648661,1001148,598392,562802,90046,794171,209873,148497,556142,177454,345044,825311,330127,936621,757173,866491,446878,745595,76332,685491,905742,172688,937761,996441,846837,828900,181293,403665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001405s ]