SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 620106 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 620106 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110600,915849,293367,61038,352498,705562,1036882,875874,528528,133620,277117,40723,360301,963380,199649,759447,625511,907626,40133,930030,616196,199313,979856,675708,248299,503014,298057,597010,970535,303995,543651,62792,431727,237577,1021476,317755,347762,407144,931153,931971,334677,423451,94390,908325,481605,531842,630570,384198,214701,820269,58130,357589,30826,764352,561965,411343,642926,401598,688895,396804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 620106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 620106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]