SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562235 LIMIT 1 [ RunTime:0.000771s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562235 [ RunTime:0.001433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154983,749143,176990,1013058,668428,814790,409240,393559,549054,749734,254066,433444,407151,661069,667847,677873,1039857,142182,925170,176031,1008669,522317,576135,575308,914119,927019,369728,738773,466666,680072,144451,906650,943153,311833,526520,678390,172133,598286,221745,433071,207285,361578,743857,133801,2774,703233,743566,81568,536339,1004093,773962,921879,913045,860514,561469,595657,596484,1041336,134961,1018769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562235 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562235 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001817s ]