SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491317 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491317 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491815,420514,484522,804352,41212,155599,400244,1022828,398367,1022476,716056,686943,106167,646953,1012136,848737,439440,1027408,27208,438595,901387,754194,899655,170,90779,435141,736860,872067,866030,744074,87002,876671,92325,11747,1021120,38199,1003952,638066,252609,980180,890025,405942,586245,537775,473077,1048408,439587,140469,372937,916483,715647,226894,915316,251228,676256,166762,1035125,321306,547130,939906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]