SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531535 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531535 [ RunTime:0.002079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543318,608334,55240,945484,568680,697761,748903,964541,155155,888228,855258,558290,563303,1004838,291212,711159,535765,582511,705217,1041504,798694,182613,323138,31405,242019,298808,297828,28605,358198,624136,674352,168979,957760,968138,817301,266907,919613,49518,140125,871055,651108,49419,391008,21746,390921,995456,206655,421187,294029,282477,289500,25322,25706,346921,367360,251190,408399,647145,359169,864962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]