SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042833 LIMIT 1 [ RunTime:0.000816s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042833 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886641,62589,749723,401455,278519,30568,617367,152041,1002445,22029,967918,885464,400784,377646,717971,30018,777918,527322,336027,29943,670135,480239,177223,384294,532255,950794,68459,883847,797371,431800,20135,164223,185586,878791,31767,648137,244746,15017,600339,347543,89961,700745,849904,507774,104500,1005795,794640,760310,994414,335150,339992,595281,411024,648204,27811,954009,10886,941221,392714,961594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]