SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40577 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40577 [ RunTime:0.003857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774779,75787,741425,71500,197890,951579,116614,792397,387448,935561,491524,306989,3870,427327,571149,633996,546634,25163,568395,975978,974271,523080,1022356,464286,148743,707900,126872,187471,156895,825885,487372,491391,1007848,717205,19158,740485,902615,334083,61407,735092,26961,330755,585027,220478,60446,66384,353090,254993,392248,576527,417301,100716,868763,66004,8315,217943,828630,500009,201251,534074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40577 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40577 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]