SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 643090 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 643090 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384448,102017,813497,398334,127061,841524,483064,16968,763449,555893,392558,300071,409004,584666,622445,824875,235435,244750,936871,251005,229294,850610,163065,90040,905091,793396,252636,826191,521839,283986,487666,496860,606560,514019,493807,142251,563994,612649,49908,472365,85571,697089,1039501,1007802,729054,335495,554726,538167,49542,428866,789849,538955,966882,886623,747075,869127,853407,926469,113559,993641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 643090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 643090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]