SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510096 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510096 [ RunTime:0.002767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439276,851807,414473,780094,148508,18042,209271,207501,396536,269549,14623,793963,549588,327196,824235,525551,235868,949661,377560,801083,902109,31482,636382,288811,860873,603976,246232,31519,436538,716227,607413,160592,850470,419124,26458,912871,209102,781636,339142,456277,910320,518775,669233,335874,412900,131813,85484,516873,173845,1016641,316370,480283,188757,796714,1029805,682072,357598,865531,273092,324260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]