SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462053 LIMIT 1 [ RunTime:0.001034s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462053 [ RunTime:0.001353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38055,860661,436085,511543,539901,31408,392114,894056,846991,427439,42643,289872,294826,984798,358203,86903,907202,773229,486008,8061,878624,656363,677781,673831,893752,841851,537767,285822,42062,903607,189373,869834,735681,659480,420970,1039448,1008046,887813,512203,637987,365780,237171,367384,668314,70015,343770,784606,943476,120722,573463,560420,27525,83300,238398,980896,170923,19685,880908,469229,98794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]