SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040698 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040698 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897820,223598,594578,691752,624115,527609,197192,945693,879906,544440,811903,559494,1024782,713308,207875,866005,509468,221616,353150,217186,279136,789997,64160,710674,428121,592252,865932,386725,774713,906147,623988,699364,1038183,981236,247727,608856,401912,973367,943134,1013286,311923,814957,710891,210960,917236,629137,877063,665860,316814,713665,200163,482723,1006483,390530,903666,386941,568082,645145,1014958,519901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]