SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45079 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45079 [ RunTime:0.002751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535911,288179,809423,769887,113360,14904,564389,144196,805890,791637,356514,101386,788568,430932,584514,804878,211941,294600,705553,988435,213914,750933,981269,295875,622344,1015556,454004,649841,1016137,196813,929200,657950,793625,82104,89270,6159,172329,703076,907193,308123,231915,434437,13235,804801,69891,650841,10002,656828,956352,399304,142733,871823,473409,1012374,715383,352789,903003,822580,1048870,756046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]