SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510530 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510530 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038694,399200,838328,193619,578614,886934,388127,390766,255801,216158,573788,593316,716822,149590,681975,533893,96268,731143,993951,399568,745559,845118,554508,963411,1002649,26450,187065,1004103,637770,514620,104648,36251,666787,729022,605081,536201,296281,508409,154614,424443,116323,47882,935018,217134,408738,55961,110900,69401,1044068,761015,525760,999378,610028,1030075,197566,144073,60961,670944,997743,147434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]