SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004537s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820059 LIMIT 1 [ RunTime:0.002009s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820059 [ RunTime:0.002329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815030,344830,863092,137493,860505,612818,382272,1024438,842251,489914,613417,563299,75102,507597,7395,268764,66518,423384,636735,207214,161231,57576,701240,83949,638626,146156,623726,541892,505352,775136,517020,635158,149989,103133,225943,708271,57386,539790,871102,264431,447238,208316,319874,895604,41721,1023753,578115,60722,663039,457438,892917,305969,616929,995755,203284,612763,433281,490897,679938,514344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]