SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146203 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146203 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438769,142147,686896,968373,838460,102951,593294,472830,744632,701880,33550,787466,409571,251283,460797,815657,327540,53945,31958,210467,860582,538129,431809,908121,988182,517923,152726,74015,205751,456010,71863,794190,237819,779968,907810,374058,713359,769367,974436,677137,750838,125028,196398,426222,867753,381726,945215,654174,1003311,1017623,872199,808657,654020,163538,572245,606333,366080,429071,525131,158458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]