SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471615 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471615 [ RunTime:0.004272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985489,1003355,432547,434238,55991,908909,89066,468793,925728,448255,58976,36741,481744,676925,323158,582376,1036147,658082,1010076,294291,261169,665446,98478,461265,836332,669321,649828,770622,831397,948083,865059,1006028,763457,856447,612103,709100,208838,906593,296587,180695,260295,135060,635421,931351,1017442,106450,230966,913440,469151,193311,681140,997347,150663,374030,98489,289319,34322,204547,610820,50497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]