SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805908 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805908 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941957,106372,735130,197207,68315,603672,8496,598206,239026,422038,119907,234077,980767,524705,562037,706204,657695,839551,955573,969561,122141,1042591,164949,919012,524234,12131,182703,354010,184031,341804,379715,779448,868431,391185,282549,746685,319701,369102,603024,5015,1004555,728269,943635,194332,84549,306560,946663,855089,945301,241036,450353,315975,461113,148862,645117,989086,639804,1014601,497109,169316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004054s ]