SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34321 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34321 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239595,1011716,304201,312340,1026494,531238,1042010,5904,39347,982300,353352,438460,617004,638267,245046,764726,468741,942813,390621,54217,81536,681757,410597,716653,243715,85164,282366,807651,115786,953489,48207,653839,287631,754709,41402,392305,199509,14577,668100,331199,280296,329038,276644,674662,1029475,791507,640649,198915,679747,746651,564698,500833,408401,328095,150036,749642,926342,439994,604992,356892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]