SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106923 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106923 [ RunTime:0.002232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562689,773533,212292,281691,780706,28859,527812,385614,12871,403199,70128,245759,209685,327223,294898,144839,1026493,1047025,362677,497370,218673,981955,34455,993686,453503,139213,247374,91835,947436,260418,261387,29142,241312,768939,665649,411811,51484,703314,653663,755310,1027109,82190,682129,439005,738779,406056,62055,371630,887891,436672,75104,884030,929811,353383,1014032,425036,17214,692697,91432,778463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]