SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555091 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555091 [ RunTime:0.003449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575401,64317,528473,928129,244551,252824,459389,213362,704766,696933,422744,317156,399783,109441,540328,243810,553105,873936,876227,319272,174656,534347,790258,784940,105016,83763,656051,357035,292875,940223,359103,644920,131982,586291,1038306,794662,212228,447701,377391,201796,624287,533999,558116,237720,630578,750561,634630,247935,232784,355435,906583,808375,951190,74632,391371,421065,419245,807279,419279,13730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]