SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530037 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530037 [ RunTime:0.003019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179066,321824,948074,539600,329847,917618,308901,366019,915463,130532,351473,663081,848655,30688,197703,868901,617458,488330,391893,1018286,58527,237645,460734,714262,681655,80652,135299,449492,807580,407760,909257,93382,796895,534741,886628,353691,814066,285640,336185,684003,189213,556252,967924,515100,302185,343829,355784,487740,661051,433186,99890,483460,880987,411125,839274,919282,593937,226738,169430,1016037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]