SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311026 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311026 [ RunTime:0.002244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610874,664680,209238,684673,554292,323344,677769,57593,895054,290360,300717,54253,94883,737647,873311,621129,214080,248516,85844,497670,2767,644138,934337,996060,415695,690356,1001580,966712,152942,427945,391988,1009844,543187,864408,925799,841133,679148,416805,956549,295388,160412,677618,238128,266812,432918,283510,172615,268750,193159,397903,463003,135937,1005934,1037280,945419,274481,180528,1021526,306128,179875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]