SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106984 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106984 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622683,651973,228809,932402,687246,1031728,605125,314656,543046,154159,376752,341916,790918,150539,94362,802415,952725,741902,918018,267270,118958,977662,846533,988515,269326,98200,776843,932295,951475,251833,291485,1036588,887528,909436,268175,275267,970822,498795,364837,797622,718239,641300,223948,783839,524579,688065,10378,146090,487680,423818,25414,490285,509078,844573,713151,571411,850785,1040533,464284,554710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]