SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001771s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804496 LIMIT 1 [ RunTime:0.001133s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804496 [ RunTime:0.002320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43220,37883,327514,1020172,757939,324606,564755,962059,951850,37299,575454,22048,872933,95770,433957,370914,150756,748133,770896,571426,891816,352568,555250,118503,391253,605331,483613,576029,352999,785889,34436,461374,386111,232539,696125,348744,920338,367801,139370,176619,132242,271529,929515,691836,551051,60956,718922,316318,820958,4570,236254,250733,447582,825335,368809,816435,120232,993022,559563,442738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]