SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331612 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331612 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614361,579078,506838,583451,416131,714845,1027387,506589,859159,882719,907062,299610,554486,786135,386102,136079,521353,415714,779018,91038,732342,858910,807083,1020672,946440,876817,425474,737875,241590,885772,989015,518105,633713,754679,129649,1045784,141238,898726,550343,711450,773167,559702,690462,143679,267478,350959,964454,539048,242724,131204,752473,456375,123146,838224,265808,915715,1030164,241011,657313,138066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]