SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509244 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509244 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942102,537395,707448,545532,491590,691433,105878,922617,217914,989365,962512,205386,419962,72251,897908,320328,436851,43780,1041758,565181,628839,455771,239931,290510,752098,734058,778201,258330,706955,661617,676860,227491,619735,399584,841427,810598,650923,58219,756505,43264,66320,995222,335795,754827,1010792,101639,185481,173028,729090,844074,228753,671645,934382,604171,192358,873815,172388,748768,1012534,119463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]