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` = 395781 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395781 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845505,12783,708805,325453,354142,433301,827373,601986,738862,1018945,478401,202141,79904,100607,802163,630899,968052,719505,13869,728151,825790,155455,509269,282249,112458,851158,88547,853894,1009045,294282,738215,222640,353105,529123,865477,44048,976441,276946,76062,552531,938229,222626,383323,764293,770842,566388,407909,95898,277983,407021,761454,1012374,579387,1004892,367991,905448,333058,124403,1040140,823916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]