SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510430 LIMIT 1 [ RunTime:0.001519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510430 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383824,387012,101909,411395,552353,845293,635943,401192,703655,385958,826850,417100,639645,223269,152341,802519,1012183,117753,253074,643620,997085,61779,539631,63528,131066,270084,550419,755268,420084,484477,380915,181957,214539,556564,632250,918765,1036579,686495,147860,200297,658544,462762,587044,11002,810965,337526,281067,1028788,769704,2652,494649,598168,61546,12304,288664,165715,917398,88678,765026,538886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001677s ]