SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406430 LIMIT 1 [ RunTime:0.000832s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406430 [ RunTime:0.002428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952178,269886,783659,824532,1020417,931501,570901,186620,524660,912998,287048,399546,532899,407247,830074,793775,565222,232108,935097,1036448,729388,99668,163130,139584,314544,50,806295,905814,763872,813820,36866,937832,814300,822727,759517,422053,27534,824394,968901,776700,504646,505405,576184,325478,1035925,519562,543563,547556,44630,672054,427725,568087,499736,73327,1027488,431428,170490,132048,20259,671903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000857s ]