SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565412 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565412 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360025,401753,584310,815040,236437,277757,994308,259698,3485,177148,122717,346417,433149,487284,147868,178557,429354,605580,535176,358167,762820,314639,528685,978486,705685,97539,293184,295810,375448,9537,675184,352087,693031,997852,656706,550624,311029,875616,871270,715309,758734,652628,452310,143770,73779,24023,871585,236878,913686,379183,217411,378411,827508,654353,1044412,506190,1008381,51092,1046314,159211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]