SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671480 LIMIT 1 [ RunTime:0.000538s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671480 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304451,655789,655593,1044995,575913,495144,854734,403250,760911,163639,182036,216011,542242,496624,667582,1005344,992040,907433,693706,626225,490390,615825,317429,577292,51094,237785,686250,63260,758266,531433,153356,437351,468674,962235,930799,844555,244604,405009,98136,303864,627993,927928,428779,90016,749571,1037970,847768,794982,82197,190199,566340,267288,66991,846554,986795,24299,949165,384743,570298,523072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]