SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534440 LIMIT 1 [ RunTime:0.007364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534440 [ RunTime:0.002395s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36478,50929,125729,1047303,982663,497301,1006048,1037944,308919,814781,749886,258570,570205,499826,330413,308094,820317,814959,79230,340342,609530,513366,505118,58153,823955,459109,559009,320044,630133,382450,822669,605895,263581,255574,913589,243927,463456,44765,381975,621044,779339,341918,495683,139811,69507,392050,399308,505062,977291,330219,777473,225224,145871,83301,723738,1006374,437959,476369,933968,579714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]