SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196107 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196107 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012349,380022,525557,197671,509546,1000148,815409,267958,696894,330215,479206,973620,582310,628312,920091,438334,777666,252953,55998,51611,318949,232850,92871,522253,864213,968403,151262,880800,26447,460547,768695,641218,12639,1012795,251788,627998,225040,415813,114074,312598,947882,653169,940131,1031979,712458,363673,204437,559392,692624,277482,608305,1020716,537893,352070,621180,822872,270718,301097,371090,627290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]