SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100251 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100251 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47211,763065,120056,912977,406264,300506,919441,284903,647230,600416,164212,460658,351705,960562,1012846,266271,687368,169180,119408,112065,831100,425735,181580,940326,580436,289336,72627,58191,114893,452746,832621,296260,797066,623394,786794,391719,811924,233600,892682,887192,766237,888215,19726,519630,612851,640309,499742,176259,602838,622633,901455,3966,359390,876977,463692,895329,125332,465785,203099,345080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]