SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531126 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531126 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909819,885008,70418,277973,573577,1046168,873868,274024,664209,132534,374570,95974,317149,669449,119927,419191,354034,682595,1028726,121382,762163,374710,585017,995997,524627,662826,481747,157651,464504,799098,436522,68677,646100,863135,171364,859454,919093,726851,296475,637879,25339,768036,887830,385641,20838,1009068,267491,687172,195628,823994,749131,96138,134590,631101,425305,734950,121403,502683,360335,209078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]