SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40060 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40060 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595966,191723,580243,361344,69356,17802,990558,918397,405198,404084,441832,158712,840950,997663,982248,914919,545025,506271,253350,502705,3375,815914,926277,134648,301775,291356,415324,894756,843539,68004,302109,1032961,83156,719467,1021805,924979,163811,41926,618146,480458,467132,600691,477212,1009915,234742,447339,692189,580206,95886,1007010,584690,696111,1021641,344955,487401,90694,1036228,304496,950447,83095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]