SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201599 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201599 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45032,515644,191210,355494,80049,735287,984408,81148,787858,835386,1038025,404044,569963,781197,743243,99396,693273,273116,986783,960909,31840,324979,516727,528119,335380,544175,1017804,94433,930948,265448,841777,884224,435162,493004,751224,892241,87301,974249,680799,190244,299486,184046,1017102,574636,830262,788419,431303,187662,451357,329496,818665,367094,108274,881175,767710,688507,500614,162066,75984,373229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]