SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538541 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538541 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881422,544091,754593,771150,870767,40298,445479,267257,798453,361134,821722,1012148,984930,688282,50623,570858,604344,21207,391259,363374,892258,840506,818912,134949,294846,11428,151380,269365,172458,853417,984938,990877,962534,691697,11228,195312,96138,193211,757777,442304,329562,130812,335579,339285,278300,71161,999348,177318,324870,340466,549616,206378,60447,108991,592543,885542,376801,357627,1011407,172947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]