SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543409 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543409 [ RunTime:0.001480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196724,810437,487199,134665,203728,664948,9768,962653,892457,618944,401032,910280,584,502751,328357,7285,234902,522153,213141,964256,533409,46345,1000818,858001,726164,523421,278161,586865,622848,179168,361434,12945,241963,249356,493023,148380,451471,48431,561130,456648,583090,833196,752258,613896,957487,409702,898296,844508,632300,399778,725749,395893,292413,966665,671041,575832,221058,801553,328567,645198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]