SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467620 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467620 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125019,462637,167993,460698,110778,238225,173094,331505,175133,182553,719730,823315,513473,573480,1019612,653381,748052,373640,994607,937853,499,667197,180935,732911,212511,690564,748480,542094,841093,822788,831609,117535,912790,229170,629097,588802,730093,757806,217221,178444,45706,544743,127951,43883,933844,219966,183377,541741,880446,619526,816980,225799,301978,888612,99908,624870,130990,75840,803539,737972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]