SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473970 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473970 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698531,267928,359250,108933,577020,47260,72193,282015,580664,346379,154845,429764,790165,180954,233623,28824,54381,802665,951687,576814,923640,97038,186583,925952,631691,197211,395940,306535,194356,518724,45310,64904,50195,1025469,69433,1040806,993487,295440,864299,267675,327611,1043679,69787,509395,741791,763231,840667,268310,49569,33883,970218,448341,447700,606855,408964,842621,89569,254708,742741,654815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]