SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414254 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414254 [ RunTime:0.002471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16374,766136,628753,805090,404920,464307,80752,872364,528949,921279,153372,868617,583862,484617,492320,823175,475180,239920,646059,659998,29046,440609,32368,763484,847454,419781,393120,627625,478629,851911,58232,873052,1041469,35913,569961,251752,60480,824624,623951,400644,309791,138593,23412,720074,548132,905274,539503,860159,36132,755119,706512,884764,518970,389084,954096,701358,766363,907577,141019,865442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]