SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491023 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491023 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802545,397768,262041,879949,730400,704906,249909,460928,985392,970476,541246,958961,311343,549051,97262,105804,843479,498585,977393,597424,747921,674085,7819,986194,43919,303972,629576,394994,620733,302224,316038,527319,807336,754700,423916,233849,348362,831478,33049,135117,567837,322228,981562,509154,112798,938726,139519,188122,830700,1043942,1010386,873717,176248,1006917,531729,854773,297523,92282,66020,182169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001018s ]