SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001707s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541718 LIMIT 1 [ RunTime:0.000952s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541718 [ RunTime:0.002502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629772,1040737,412834,507103,570364,79590,908058,487741,241110,332273,1000965,490163,34817,681222,650928,530154,566242,516009,664593,830803,637051,662808,542125,335163,469009,500584,809606,687723,238970,30592,805083,672050,281250,355263,158873,792028,735685,153965,480225,831880,343753,118039,911729,10633,974985,383194,190448,669145,580911,675353,181748,890749,273706,356692,1017957,2636,158814,609765,647634,106033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001473s ]