SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043456 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043456 [ RunTime:0.002515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544695,749280,608509,803628,328429,999151,773343,552843,993074,808148,755433,644864,983724,429343,461489,454110,874609,1034700,754230,645518,462163,590041,374299,655348,439062,764449,643570,860351,463949,561267,39776,795612,248277,137645,530611,981970,529618,689511,81616,334834,1013555,1036282,341499,479830,690141,136381,250650,1008016,482600,754872,662478,843016,289671,98603,933493,23144,176180,1047350,787572,367352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043456 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000775s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043456 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003935s ]