SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003910s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559015 LIMIT 1 [ RunTime:0.002362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559015 [ RunTime:0.004278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216075,111321,427366,64584,539167,1047222,529972,922611,943530,511518,1040385,220266,97643,78432,236515,47870,836628,420139,497566,690400,812221,755111,731517,680327,103984,886726,686831,568564,941247,462664,228784,816017,535707,316756,711865,753929,258805,493627,412659,9,309667,442404,294144,599704,661185,283383,81575,583139,784675,779530,149215,253412,135761,940315,902583,416104,822461,1030417,607854,52154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]