SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021474 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021474 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920440,155550,1027304,316670,797776,663877,494547,618266,378141,264598,594402,893407,463641,978575,821165,849435,917010,691792,613337,546344,565861,458828,867651,338992,364179,970473,239411,572409,42057,772596,891151,63486,968852,948775,680466,179402,897661,784269,116950,739886,494326,117796,927208,15829,373967,538884,251017,364312,466980,219080,172970,996067,398703,99519,468270,189648,653010,957260,557029,1043158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]