SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533253 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533253 [ RunTime:0.003547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888299,843330,465368,72090,693846,462766,685720,670437,873727,723950,533459,550187,94675,312242,923558,529255,568384,686548,149582,696093,434243,7574,8913,136291,1000564,426731,327119,81149,743958,1031497,920882,159263,423652,264084,19180,991594,484666,233894,563003,134127,1010093,932077,808368,525689,562604,458015,176004,815546,797450,78498,141756,496535,816114,628571,814995,724331,769081,232239,284476,545629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]