SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326987 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326987 [ RunTime:0.001439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401346,905801,889142,835250,621774,806195,121893,279943,233957,11134,222342,746577,792287,319964,777385,981109,789202,698624,733814,14322,829160,154482,583505,926200,412850,382923,865767,18188,411408,116180,200546,476246,343198,79207,206437,636313,234521,351694,431121,418628,755355,570344,942125,581532,273689,272184,814674,394135,997692,719595,262760,281041,167951,458920,583898,372987,267657,152106,616567,1045215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]