SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037813 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037813 [ RunTime:0.003413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294995,731288,249978,898082,337767,924206,120467,820053,118056,61921,301229,780426,382511,86853,189701,425328,676375,724462,35454,94365,414122,42361,936405,30014,175584,349224,154104,521841,944291,500763,971453,486461,836539,111247,352909,908334,282737,1003660,1024975,278857,775600,129404,702260,514480,996655,867046,66143,234083,948322,411550,496143,44993,234614,366935,98763,1009769,391299,826378,531968,666485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]