SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50707 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50707 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185039,995145,391909,1022898,763126,885307,406079,566006,555452,786913,130097,186883,1010709,469736,87499,617606,630434,270276,664135,260537,419452,258078,958989,417877,743087,754297,744548,166663,317962,311610,709930,515168,23869,358468,295963,848144,1010806,200653,986720,230145,353314,920460,303817,272131,115983,731116,944811,133964,298537,274653,946423,320006,1043671,196870,655275,591429,806152,460981,320339,53548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50707 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50707 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]