SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002927s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004747 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004747 [ RunTime:0.002360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524531,188692,675229,156896,891511,758677,159024,590850,677986,334615,845563,664057,274450,989886,755439,649532,978224,67923,902366,348107,461475,819969,457437,258590,699272,444101,976263,476150,301940,1036670,751999,248284,633633,642364,79784,861310,845270,361325,864128,104695,851175,409464,393609,62222,424631,815481,868038,416569,624432,944457,991858,997298,844849,588112,835723,230288,462509,396868,332206,888237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004747 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004747 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]