SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410307 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410307 [ RunTime:0.002866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980517,912656,754982,179243,227840,853186,179089,809646,225893,953534,266860,566711,912490,224196,615423,579296,901049,76906,7101,40033,796113,328767,29266,472611,41162,23625,386303,35843,757401,254348,248706,886029,512110,256965,207752,691883,95355,949127,264891,392358,763828,32412,167501,316751,1007728,12716,576606,29658,571924,594616,169225,288361,925627,249020,750573,210942,63895,798545,981393,749617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]