SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015207 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015207 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445113,663665,71053,839002,474107,738270,936039,582329,378679,741,602952,805149,483615,310845,1020642,585179,873581,849275,97030,810309,662549,729848,416470,127582,749196,287101,79553,301501,723501,165876,119732,581755,526068,909656,836404,210655,241323,435669,352964,102551,267970,244361,210744,502924,314696,597944,617311,461089,33591,939478,783701,631634,934192,235242,414168,211988,801799,638770,367065,805830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]