SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401413 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401413 [ RunTime:0.004011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741957,1028773,513429,228605,224328,66563,1009860,49925,234603,357273,16676,160001,568184,18049,392652,760747,947780,248871,188656,719750,943423,561159,696448,425181,647589,754293,942318,230174,1025512,368038,266409,929527,85839,341800,794135,305926,422910,134219,432889,624652,369746,614713,537471,759868,378696,401112,125625,773118,440725,462028,325234,795890,364059,457098,318838,365259,160647,1012330,726076,890869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]