SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469510 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469510 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13133,330094,745793,342877,440370,491277,756273,94619,848666,600240,587055,596410,370427,137084,322718,85034,1030513,802442,1038079,395289,241588,79699,508929,892076,885368,735329,333451,236365,665497,440857,447633,202311,76750,192905,458749,1026730,945150,902643,303221,965125,704844,56313,512813,293131,192848,972864,103522,299677,923552,671869,429209,1013535,253693,476490,923235,482404,500204,700125,941747,452627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001485s ]