SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402163 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402163 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341558,809906,356748,331587,401520,372262,195876,5913,309655,315081,229578,706913,4652,303447,362737,497290,702564,489712,294558,542391,815766,349296,541477,413738,247144,1042384,170099,982769,295729,517729,923971,101613,219189,783136,881569,863071,421942,230925,177976,903237,1010225,748341,1015333,95672,170227,675681,556659,677299,183395,204386,957341,552043,194637,52913,699369,856530,750495,553840,443365,665010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]